﻿CREATE TABLE [dbo].[Members] (
    [MemberId]         INT            IDENTITY (1, 1) NOT NULL,
    [FirstName]        NVARCHAR (256) COLLATE Arabic_CI_AS NOT NULL,
    [LastName]         NVARCHAR (256) COLLATE Arabic_CI_AS NOT NULL,
    [DisplayName]      NVARCHAR (256) COLLATE Arabic_CI_AS NOT NULL,
    [Email]            NVARCHAR (256) COLLATE Arabic_CI_AS NOT NULL,
    [Password]         NVARCHAR (500) COLLATE Arabic_CI_AS NOT NULL,
    [Gender]           TINYINT        NULL,
    [Birthdate]        DATETIME       NULL,
    [NationalityId]    INT            NULL,
    [CountryId]        INT            NULL,
    [CreationDate]     DATETIME       NOT NULL,
    [IsActive]         BIT            NOT NULL,
    [LastUpdateDate]   DATETIME       NOT NULL,
    [ImagePath]        NVARCHAR (50)  COLLATE Arabic_CI_AS NULL,
    [ConfessionFather] NCHAR (10)     COLLATE Arabic_CI_AS NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'1= male, 2  = female', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Members', @level2type = N'COLUMN', @level2name = N'Gender';

